Problem Note 61612: SAS® Enterprise Guide® might not support zero as the "Maximum number of rows to display in the data grid with SAS/ACCESS® data"
 |  |  |  |  |
In SAS Enterprise Guide 7.15 Hot Fix 1 and earlier, you cannot specify zero as the limit for the number of rows to display in the data grid for SAS/ACCESS data. If you enter 0, then SAS Enterprise Guide automatically changes the value to 1. You set this option using Tools ► Options ► Data ► Performance ► Maximum number of rows to display in the data grid with SAS/ACCESS data ► Limit number of rows to.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After the hot fix is applied, you can specify zero as the row limit for SAS/ACCESS data.
Setting the value to zero is useful when you are working with large DMBS data. For example, setting this value to zero can prevent SAS Enterprise Guide from locking up when it tries to retrieve a large amount of data. Setting the value to zero retrieves the column names, but not the data rows.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | z/OS | 7.15 | 8.1 | 9.4 TS1M5 | 9.2 TS1M0 |
| Microsoft® Windows® for x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.2 TS1M0 | ||
| Microsoft Windows 8 Enterprise 32-bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 7.15 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 7.15 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 for x64 | 7.15 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Datacenter | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 7.15 | 8.1 | 9.4 TS1M5 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 7.15 | 8.1 | 9.4 TS1M5 | 9.2 TS1M0 | ||
| HP-UX IPF | 7.15 | 8.1 | 9.4 TS1M5 | 9.2 TS1M0 | ||
| Linux for x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.2 TS1M0 | ||
| Solaris for x64 | 7.15 | 8.1 | 9.4 TS1M5 | 9.2 TS1M0 | ||